package com.ruoyi.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.system.domain.BsQiyeBusinessData;
import com.ruoyi.system.domain.dto.BsQiyeBusinessDataCountDTO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 企业经营数据Mapper接口
 *
 * @author ruoyi
 * @date 2023-11-23
 */
public interface BsQiyeBusinessDataMapper extends BaseMapper<BsQiyeBusinessData> {


    //注意$不要改
    @Select("select qiye_id qiYeId,count(id) countNum from bs_qiye_business_data where qiye_id in (${idsString}) AND del_flag='0' and type=#{type} group by qiye_id")
    List<BsQiyeBusinessDataCountDTO> getUnReportNum(@Param("idsString") String idsString, @Param("type") String type);
}
